python如何提取csv文件某一列的第一个字符_如何在python中从csv文件中提取特定列并为其编写新的csv...

Pandas是一个具有强大的method来读取csv文件的库。在

如果您想从同一行中读取每一列，下面的脚本将完成这项工作（请注意，只有2行python行是有用的）：import pandas as pd

# Give the name of the columns

colnames = ('skip1', 'skip2', 'skip3', 'Col0','Col1','skip4','Col2','skip5','Col3','Col4','skip6')

# Give the number of lines to skip

nbskip=4

# Give the number of rows to read (you can also filter rows after reading and remove the empty ones)

nrows=3

#List of columns to keep

keep_only = ('Col1','Col2','Col3')

#Read the csv

df = pd.io.parsers.read_csv('test.csv',

header=None,

skiprows=nbskip,

names=colnames,

nrows=nrows, # Remove if you prefer filter rows

usecols=keep_only)

# If the number of lines to keep is unknow,

# you can remove empty lines here

#Save the csv

df.to_csv('result.csv', index=False)